---
title: ODBCErrors Object (Excel)
keywords: vbaxl10.chm528072
f1_keywords:
- vbaxl10.chm528072
ms.prod: excel
api_name:
- Excel.ODBCErrors
ms.assetid: 2f1c8a6b-2b9d-fc2c-7caa-289652ac8e24
ms.date: 06/08/2017
---


# ODBCErrors Object (Excel)

A collection of  **[ODBCError](odbcerror-object-excel.md)** objects.


## Remarks

 Each **ODBCError** object represents an error returned by the most recent ODBC query. If the specified ODBC query runs without error, the **[ODBCErrors](odbcerrors-object-excel.md)** collection is empty. The errors in the collection are indexed in the order in which they're generated by the ODBC data source. You cannot add members to the collection.


## Example

Use the  **[ODBCErrors](application-odbcerrors-property-excel.md)** property to return the **ODBCErrors** collection. The following example refreshes query table one and displays any ODBC errors that occur.


```vb
With Worksheets(1).QueryTables(1) 
 .Refresh 
 Set errs = Application.ODBCErrors 
 If errs.Count > 0 Then 
 Set r = .Destination.Cells(1) 
 r.Value = "The following errors occurred:" 
 c = 0 
 For Each er In errs 
 c = c + 1 
 r.offset(c, 0).value = er.ErrorString 
 r.offset(c, 1).value = er.SqlState 
 Next 
 Else 
 MsgBox "Query complete: all records returned." 
 End If 
End With 

```


## See also


#### Other resources


[Excel Object Model Reference](http://msdn.microsoft.com/library/11ea8598-8a20-92d5-f98b-0da04263bf2c%28Office.15%29.aspx)


